﻿if exists (select * from sysobjects where id = object_id(N'pBUGLOGStatusAdd') and sysstat & 0xf = 4) drop procedure pBUGLOGStatusAdd 
GO

-- Creates a new record in the [dbo].[Status] table.
CREATE PROCEDURE pBUGLOGStatusAdd
    @p_Status varchar(25),
    @p_StatusDescription varchar(250),
    @p_StatusID_out int output
AS
BEGIN
    INSERT
    INTO [dbo].[Status]
        (
            [Status],
            [StatusDescription]
        )
    VALUES
        (
             @p_Status,
             @p_StatusDescription
        )

    SET @p_StatusID_out = SCOPE_IDENTITY()

END

